CREATE TABLE [dbo].[JY_News]
(
[JY_News_ID] [int] NOT NULL IDENTITY(1, 1),
[JY_News_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_News_Title] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL,
[JY_News_From] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_News_Views] [int] NULL,
[JY_News_Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JY_News_Add_User] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_News_Add_Time] [datetime] NULL,
[JY_News_Update_Time] [datetime] NULL,
[JY_News_Status] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_News_Top_Status] [int] NULL,
[JY_News_ZB_Unit] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_News_CB_Unit] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_News_Hold_Time] [datetime] NULL,
[JY_News_Hold_Add] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JY_News] ADD CONSTRAINT [PK_JY_News] PRIMARY KEY CLUSTERED  ([JY_News_ID]) ON [PRIMARY]
GO
